Author Details

Scroll

Refine your search

Collections

Engineering Collection

Co-Authors

Journals

Software Engineering

Year

2022

Authors

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z All

Raslan, Atef

Comparative Study of Data Warehouse Modeling Techniques

Abstract Views :78 | PDF Views:0

Authors

Atef Raslan ¹, Ahmad Saleh ²

Affiliations
1 Department of Computer Science, Institute of Statistical Studies and Research, Cairo University, EG
2 Faculty of Graduate Studies for Statistical Research, Cairo University, EG

Source

Software Engineering, Vol 14, No 9 (2022), Pagination: 138-141

Abstract

The continuous increase in data volume and data sources leads to an urgent need for analyzing this data. Hence the importance of designing a data warehouse model corresponds to the needs of companies and it’s considered as a key element in most of the data Analysis Systems. There are two main approaches in building the DW. The first is the Top-Down approach or the enterprise model for Bill Inmon and the second approach to Kimball which called Bottom-Up approach or the dimensional model. Each one of these approaches is widely used in building DW with some differences in the design. This paper highlights the difference between the two approaches and proposes recommendations for selecting the proper design.

Keywords

Data Warehouse, Top-Down, Bottom-Up, OLTP, OLAP and Data Mart.

Full Text

References

B. Calabrese, “Data cleaning,” Encycl. Bioinforma. Comput. Biol. ABC Bioinforma., vol. 1–3, pp. 472–476, 2018, doi: 10.1016/B978-0-12-809633-8.20458-5.

L. Yessad, “Comparative Study of Data Warehouses Modeling Approaches: Inmon, Kimball and Data Vault,” pp. 95–99, 2016.

J. George, “A Comparative Study of Data Warehouse Architectures: Top Down Vs Bottom Up,” vol. 5, no. 9, pp. 43–46, 2019.

Tanmay Sinha, “OLAP vs. OLTP: What’s the Difference?” 2021. https://www.ibm.com/cloud/blog/olap-vs-oltp

P. Ponniah, Data Extraction, Transformation, and Loading, in Data Warehousing Fundamentals for it Professionals, Second Edition. 2012.

D. P. Du Plessis, “A data warehouse model for quicker and less expensive implementation,” ACM International Conference Proceeding Series. 2020. doi: 10.1145/3415088.3415116.

A. Gutiérrez and A. Marotta, “An Overview of Data Warehouse Design Approaches October 2000,” no. October, 2000.

G. Garani, A. V. Chernov, I. K. Savvas, and M. A. Butakova, “A Data Warehouse Approach for Business Intelligence,” Proc. - 2019 IEEE 28th Int. Conf. Enabling Technol. Infrastruct. Collab. Enterp. WETICE 2019, pp. 70–75, 2019, doi: 10.1109/WETICE.2019.00022.

Q. Yang, M. Ge, and M. Helfert, “Analysis of data warehouse architectures: Modeling and classification,” ICEIS 2019 - Proc. 21st Int. Conf. Enterp. Inf. Syst., vol. 2, pp. 604–611, 2019, doi: 10.5220/0007728006040611.

C. Ballard, D. Herreman, D. Schau, R. Bell, E. Kim, and A. Valencic, “Data Modeling Techniques for Data Warehouse,” Zenithresearch.Org.in, vol. 2, no. 2, pp. 195–196, 2012.

W. O’Connell, “Trends in Data Warehousing,” Proc. 2004 VLDB Conf., vol. 6, no. 8, p. 1224, 2004, doi: 10.1016/b978-012088469-8.50109-1.

A Proposed Approach Using Test Driven Development on Extreme Programming

Abstract Views :86 | PDF Views:0

Authors

Atef Raslan ¹, Al- Hussein A. Galal ², Ahmad Awwad ³, Angelo Saber ⁴, Demiana Rushdy ⁵, Hoda Ali ⁵, Rania Magdy ⁵

Affiliations
1 Department of Computer Science, Faculty of Statistical Studies and Research, Cairo University, EG
2 the Department of Software Engineering, Faculty of Statistical Studies and Research, Cairo University, EG
3 Department of Software Engineering, Faculty of Statistical Studies and Research, Cairo University
4 Department of Software Engineering, Faculty of Statistical Studies and Research, Cairo University,, EG
5 Department of Software Engineering, Faculty of Statistical Studies and Research, Cairo University, EG

Source

Software Engineering, Vol 14, No 9 (2022), Pagination: 142-146

Abstract

Over recent years, software teams and companies have made attempts to achieve higher productivity and efficiency and get more success in the competitive market by employing proper software methods and practices. Test-Driven Development (TDD) is one of these practices [1]. So that this study aims to apply TDD on Extreme Programming (XP) agile methodology in every iteration. The present study tried to briefly report the results of applying TDD on XP with an application done before with XP to enhance testing in iteration phases which means more quality and efficiency .

Keywords

Agile Software Development, XP, TDD, Unit Test

Full Text

References

V. Bakhtiary, T. J. Gandomani, and A. Salajegheh, “The effectiveness of test-driven development approach on software projects: A multi-case study,” Bull. Electr. Eng. Informatics, vol. 9, no. 5, pp. 2030–2037, 2020, doi: 10.11591/eei.v9i5.2533.

S. Al-Saqqa, S. Sawalha, and H. Abdelnabi, “Agile software development: Methodologies and trends,” Int. J. Interact. Mob. Technol., vol. 14, no. 11, pp. 246–270, 2020, doi: 10.3991/ijim.v14i11.13269.

A. Elbanna and S. Sarker, “The Risks of Agile Software Development: Learning from Adopters,” IEEE Softw., vol. 33, no. 5, pp. 72–79, 2016, doi: 10.1109/MS.2015.150.

A. Shrivastava, I. Jaggi, N. Katoch, D. Gupta, and S. Gupta, “A Systematic Review on Extreme Programming,” J. Phys. Conf. Ser., vol. 1969, no. 1, pp. 0–11, 2021, doi: 10.1088/1742-6596/1969/1/012046.

M. M. Moe and J. C. Sanchez, “International Journal of Trend in Scientific Research and Development (IJTSRD) Comparative Study of Test-Driven Development (TDD), Behavior-Driven Development (BDD) and Acceptance Test-Driven Development (ATDD) the Creative Commons Attribution License (CC”, [Online]. Available: http://creativecommons.org/licenses/by/4.0

O. Sohaib, H. Solanki, N. Dhaliwa, W. Hussain, and M. Asif, “Integrating design thinking into extreme programming,” J. Ambient Intell. Humaniz. Comput., vol. 10, no. 6, pp. 2485–2492, 2019, doi: 10.1007/s12652-018-0932-y.

C. V. Geambaşu, I. Jianu, I. Jianu, and A. Gavrilă, “Influence factors for the choice of a software development methodology,” Account. Manag. Inf. Syst., vol. 10, no. 4, pp. 479–494, 2011.

F. Anwer, S. Aftab, S. S. Muhammad, and U. waheed Waheed, “Comparative Analysis of Two Popular Agile Process Models: Extreme Programming and Scrum,” Int. J. Comput. Sci. Telecommun., vol. 8, no. 2, pp. 4–6, 2017, [Online]. Available: https://www.researchgate.net/publication/316845761_Comparative_Analysis_of_Two_Popular_Agile_Process_Models_Extreme_Programming_and_Scrum

H. Erdogmus, M. Morisio, and M. Torchiano, “On the effectiveness of the test-first approach to programming,” IEEE Trans. Softw. Eng., vol. 31, no. 3, pp. 226–237, 2005, doi: 10.1109/TSE.2005.37.

B. D. Engineering, “Test Driven Development ( TDD ) Tools and Agile Process,” pp. 1–17, 2021.

P. Kumar and V. Dantuluri, “Investigating the Application of TDD Practice in Large-Scale Industries,” no. May, 2018.

“Test and Behavior-driven Development in Software Companies,” 2018.

F. Anwer, S. Aftab, U. Waheed, and S. S. Muhammad, “Agile Software Development Models TDD, FDD, DSDM, and Crystal Methods: A Survey,” Int. J. Multidiscip. Sci. Eng., vol. 8, no. 2, pp. 1–10, 2017, [Online]. Available: https://www.researchgate.net/profile/Shabib_Aftab/publication/316273992_Agile_Software_Development_Models_TDD_FDD_DSDM_and_Crystal_Methods_A_Survey/links/58f86bc44585158d8a6c4f11/Agile-Software-Development-Models-TDD-FDD-DSDM-and-Crystal-Methods-A-Survey.

M. S. Kenigbolo, “A case study of Test Driven Development,” no. January, p. 53, 2017, doi: 10.13140/RG.2.2.27852.92803.

Z. Khanam and M. N. Ahsan, “Evaluating the effectiveness of test driven development: Advantages and pitfalls,” Int. J. Appl. Eng. Res., vol. 12, no. 18, pp. 7705–7716, 2017.

A Proposed Approach for Evaluating Human Management Systems Using Goal Question Metric (Cameraman Management System Case Study)

Abstract Views :75 | PDF Views:0

Authors

Atef Raslan ¹, Ahmed Nour ², Ahmed Samir ³, Mohamed Fawzy ², Mohamed Galal ², Mostafa Yousif ², Wael Abbas ²

Affiliations
1 Department of Management information systems, Higher Institute of Advanced Studies,, EG
2 Department of Computer Science, Faculty of Graduate Studies for Statistical Research, Cairo University,, EG
3 Department of Computer Science, Faculty of Graduate Studies for Statistical Research, Cairo University, EG

Source

Software Engineering, Vol 14, No 9 (2022), Pagination: 147-152

Abstract

There is always a need to evaluate the programs that we have developed since developing and through the lifecycle of using them within the practicing environment. After gathering feedback from actual users, missing additional required needed items or subjects, errors or even crashing reports, we might upgrade with updated versions to an already what’s considered cutting edge software. Thus, it is essential to carry out this evaluation using GQM and some simple equations that illustrate the program.

Keywords

Software Evaluation, Goal Question Metric, Product Quality, Human Management Systems.

Full Text

References

Abdel-Rahman Mohamed, Ahmed Nour, Ahmed Samir, Ahmed El-Shiekh, Mohamed Gala, Mohamed Fawzy, Mostafa Yousif, and Wael Abbas Cameraman Management System, Faculty of Graduated Studies for Statistical Researches, Professional Diploma of Software Engineering 2021.

Rachealle Lynnwww.planview.com/resources/guide/. agile-methodologies-a-beginners-guide/history-of agile.

David Cohen, Mikael Lindvall, Patricia Costa, “An Introduction to Agile Methods,” Advances in computers, Elsevier, V. 62, pp. 20-22, 2004.

Atef Tayh Raslan and Nagy Ramadan Darwish “An Enhanced Framework for Effort Estimation of Agile Projects”, February 2018.

www.agilealliance.org/agile101/the-agile-manifesto/.

https://www.knowledgehut.com/tutorials/scrum-tutorial/scrum-history.

Apoorva Srivastava, Sukriti Bhardwaj and Shipra Saraswat ”SCRUM Model for Agile Methodology”, 2017.

Grant Allen, Mike Owens, Technical Reviewer D. Richard Hipp ” The Definitive Guide to SQLite Second Edition”.

https://www.javatpoint.com/sqlite-history.

www.sqlite.org/whentouse.html.

S.T. Bhosale , Miss. Tejaswini Patil and Miss. Pooja Patil “SQLite: Light Database System” IJCSMC,April 2015.

Esben Andreasen , Liang Gong , Anders Møller , Michael Pradel , Marija Selakovic , Koushik Sen and Cristian-Alexandru Staicu “A Survey of Dynamic Analysis and Test Generation for JavaScript”, (September 2017.

https://www.w3schools.com/js/js_history.asp.

David Flanagan “JavaScript The Definitive Guide 7th edition

https://coreui.io/changelog/.

https://coreui.io/docs/2.1/getting-started/introduction/.

https://developer.mozilla.org/en-US/docs/Learn/Server-side/Django/Introduction. [18] https://www.geeksforgeeks.org/complete-django-history-python/.

https://www.techtarget.com/whatis/definition/BSD-licenses.

https://www.djangoproject.com/.

https://www.atlassian.com/.

Victor R. Basili ,Gianluigi Caldiera and H. Dieter Rombach “The goal question metric approach”.

Rini van Solingen and Egon Berghout “The Goal/Question/Metric Method: a practical guide for quality improvement of software development”.

Boehm, Barry W., Brown, J. R, and Lipow, M. “Quantitative evaluation of software quality”, International Conference on Software Engineering, Proceedings of the 2nd international conference on Software engineering, 1976.

McCall, J. A., Richards, P. K., and Walters, G. F.,"Factors in Software Quality", Nat'l Tech. Information Service, no. Vol. 1, 2 and 3, 1977.

Dubey, S.K, Ghosh, Soumi and Rana, Ajay, “Comparison of Software Quality Model: An Analytical Approach, International Journal of Emerging Technology and Advanced Engineering, Vol 2, Issue 2, 2012.

Dromey, R. G., "A model for software product quality", IEEE Transactions on Software Engineering, no. 2, pp. 146-163, 1995.

ISO, International Organization for Standardization, "ISO 9001:2000, Quality management systems –Requirements", 2000.

ISO, International Organization for Standardization, "ISO 9004:2000, Quality management systems - Guidelines for performance improvements", 2000.

ISO, International Organization for Standardization, "ISO 9126-1:2001, Software engineering – Product Quality, Part 1: Quality model", 2001.

Trentanni, Gianluca, Biscoglio, Isabella, Fusani, Mario and Lami, Giuseppe “Establishing a quality model based evaluation process for websites”.

Vashisht, Rajeev, Neeru, Nirvair, Manhas, Sonia and Sandhu, Parvinder S.,” Reusability Evaluation Model for Procedure based software systems”, 2010.

Briand, L., Freimut, B., and Vollei, F. (n.d.). (2000). Assessing the cost-effectiveness of inspections combining project data and expert opinion. Proceedings11th International Symposium on Software Reliability Engineering. ISSRE.

Freimut, B., Briand, L., and Vollei, F. (2005). Determining inspection cost-effectiveness by combining project data and expert opinion. IEEE Transactions on Software Engineering IIEEE Trans. Software Eng., 31(12), 1074-1092.

Perry, W. E. (2006). Effective methods for software testing: Includes complete guidelines, checklists, and templates. New York: Wiley.

Gupta, V., Aggarwal, K. K., and Singh, Y.: "A Fuzzy Approach for Integrated Measure of Object-Oriented Software Testability," Journal of Computer Science, vol. 1, pp. 276-282, 2005.

Mark Zegarelli,Basic Math & Pre-Algebra Workbook for dummies, Wiley Publishing, Inc.

Judith De Klerk, Illustrated math dictionary, Pearson education australia,2007.

Frank Tapson, The oxford mathimatics study dictionary,1996.

Genedeko and Khentshin, Initial principles of probability theory Arabic version, 1969.

A Proposed Approach for Evaluating the Support Ticketing System in Enhancing Customer Relationship

Abstract Views :176 | PDF Views:0

Authors

Mohamed Salaheldin Ahmed ¹, Mohamed Ahmed Ragab ¹, Sameh Mohamed Samir ¹, Mahmoud Abdelaal Abdallah ², Atef Raslan ³

Affiliations
1 Department of Software Engineering, Faculty of Graduate Studies for Statistical Research, Cairo University,, EG
2 Department of Software Engineering, Faculty of Graduate Studies for Statistical Research, Cairo University, EG
3 Department of Management information systems, Higher Institute of Advanced Studies,, EG

Source

Software Engineering, Vol 14, No 10 (2022), Pagination: 159-165

Abstract

Customer engagement and satisfaction become important topics for most companies and are hard to achieve. Traditionally, companies work hard to overcome difficulties in processing customer requests, incidents, and complaints, as well as difficulty in evaluating the performance of their staff in responding to customer requests, moreover, it is hard to keep track of all interactions with customers. Using Support Ticketing Systems helps companies achieve customer satisfaction and evaluate the efficiency of the company's staff in meeting the needs of customers and keeping them engaged. So, we propose an approach to evaluate the Support Ticketing System and its role in enhancing customer relationships.

Keywords

Support Ticketing System, Customer Engagement, Customer Satisfaction, Checklist, Quality Checklist, GQM.

Full Text

References

PHILIP A. TITUS and JEFFREY L. BRADFORD “Reflections on Consumer Sophistication and Its Impact on Ethical Business Practice”, The Journal of Consumer Affairs, Vol. 30, No. 1, Summer 1996.

Alex Meacher, “What is Customer Engagement, and Why is it Important?”, https://blog.smile.io/what-is-customer-engagement-and-why-is-it-important, visited on 5/14/22.

Cari Murray, “What is Customer Engagement?”, https://www.outreach.io/blog/what-is-customer-engagement, visited on 5/14/22.

PHILIP A. TITUS and JEFFREY L. BRADFORD “Reflections on Consumer Sophistication and Its Impact on Ethical Business Practice”, Fatma Mizikaci, “A systems approach to program evaluation model for quality in higher education”, Emerald Group Publishing Limited, Quality Assurance in Education Vol. 14 No. 1, 2006.

Stéphane Crozat, Olivier Hû and Philippe Trigano, “A Method for Evaluating Multimedia Learning Software”, HAL Id: edutice-00000399, 2004.

Maryoly Ortega, María A. Pérez and Teresita Rojas, “Construction of A systemic Quality Model for Evaluating a Software Product”, Software Quality Journal 11(3):219-242, 2003.

https://uit.stanford.edu/pmo/requirements-gathering-checklists, visited on 6/15/22.

Barbara A. Kitchenham, “An Evaluation of Quality Checklist Proposals – A participant-observer case study”, School of Computing and Mathematics, Keele University, 2009.

VIAR, “What are quality checklists and how to use them? ”, https://www.rewo.io/what-are-quality-checklists-and-how-to-use-them, visited on 6/15/22.

Comparison of Extracting Data Using End-user Visual Tools and Traditional Methods

Abstract Views :188 | PDF Views:0

Authors

Atef Raslan ¹, Ahmed N.Abdelbaset ², Al- Hussein A. Galal ², Mohamed A. Abdelaziz ²

Affiliations
1 Department of Management information systems, Higher Institute of Advanced Studies, EG
2 Department of Software Engineering, Faculty of Statistical Studies and Research, Cairo University,, EG

Source

Software Engineering, Vol 14, No 10 (2022), Pagination: 166-170

Abstract

End users including technical and non-technical are facing many problems regarding extracting big amount of data through public websites. Our aim here is that we try to provide a way or solution to extract needed data faster, more accurate, with no code and easy to be used for technical users and nun-technical users as well.

Keywords

Visual Web Scraping Tool, RPA, UiPath, data extraction, Web crawling, Dynamic Websites, Robots

Full Text

References

Legaspi Xurxo, “Scraping de sitios web dinámicos para datos económicos,” 2016.

Joel Willers, “Methods for extracting data from the Internet,” pp. 9–25, 2019.

N. R. Haddaway, “The use of web-scraping software in searching for grey literature,” Grey J., vol. 11, no. February, pp. 186–190, 2016.

A. Extract, I. Business-, and C. W. Data, “Robotic Process Automation for Web Data Extraction”.

“December 2021,” J. Ubiquitous Comput. Commun. Technol., vol. 3, no. 4, 2021, doi: 10.36548/jucct.2021.4.

I. Dongo et al., “A qualitative and quantitative comparison between Web scraping and API methods for Twitter credibility analysis,” Int. J. Web Inf. Syst., vol. 17, no. 6, pp. 580–606, 2021, doi: 10.1108/IJWIS-03-2021-0037.

M. A. Khder, “Web scraping or web crawling: State of art, techniques, approaches and application,” Int. J. Adv. Soft Comput. its Appl., vol. 13, no. 3, pp. 144–168, 2021, doi: 10.15849/ijasca.211128.11.

J. Kharade and I. Technology, “DATA COLLECTION USING WEB SCRAPPING WITH ROBOTIC PROCESS DATA COLLECTION USING WEB SCRAPPING WITH ROBOTIC,” no. August, 2022.

D. Glez-Peña, A. Lourenço, H. López-Fernández, M. Reboiro-Jato, and F. Fdez-Riverola, “Web scraping technologies in an API world,” Brief. Bioinform., vol. 15, no. 5, pp. 788–797, 2013, doi: 10.1093/bib/bbt026.

N. Levine, “How to Copy and Select Text on Websites that Don‟t Allow It,” 2022. https://www.wikihow.com/Copy-Text-That-Cannot-Be-Copied

F. Polidoro, R. Giannini, R. Lo Conte, S. Mosca, and F. Rossetti, “Web scraping techniques to collect data on consumer electronics and airfares for Italian HICP compilation,” Stat. J. IAOS, vol. 31, no. 2, pp. 165–176, 2015, doi: 10.3233/sji-150901.

CFI Team, “Stock Keeping Unit (SKU),” 2021. https://corporatefinanceinstitute.com/resources/knowledge/other/stock-keeping-unit-sku/

Username
Password
Remember me